[dbo].[asi_GroupRoleCountByType]

SQLServer > iMIS1521GA > Stored Procedures > dbo.asi_GroupRoleCountByType

Properties
Parameters
SQL Script
Uses

Property	Value
ANSI Nulls On
Quoted Identifier On

Parameters

Name	Data Type	Max Length (Bytes)
@groupTypeKey	uniqueidentifier	16
@groupRoleKey	uniqueidentifier	16

SQL Script

CREATE PROCEDURE [dbo].[asi_GroupRoleCountByType]
    @groupTypeKey uniqueidentifier,
    @groupRoleKey uniqueidentifier
    AS
BEGIN
    SELECT COUNT(1) AS RoleCount
    FROM GroupMain INNER JOIN  GroupMemberDetail ON GroupMain.GroupKey = GroupMemberDetail.GroupKey
    WHERE GroupMain.GroupTypeKey = @groupTypeKey AND GroupRoleKey=@groupRoleKey AND GroupMemberDetail.IsActive = 1
END

GO

Uses

[dbo].[GroupMain]
[dbo].[GroupMemberDetail]
dbo